s
Test Subject API Test Subject API Microsoft 365 Microsoft 365 SharePoint SharePoint Excel Excel Test Runner 4 Excel (TR4E) Test Runner 4 Excel (TR4E) TR4E-0011Worksheet XMLTR4E creates the XML based upon the columns in the Test Case Worksheet, with the following structure <Worksheet><Row><Column Name></Column Name></Row></Worksheet> Worksheet XML TR4E-0005Request XSL-TTR4E will use the request XSL-T to convert an Excel Test Case Worksheet row into n XML or JSON payload that is sent to the Test Subject API Request XSL-T TR4E-0009Request XSL-TTR4E will load the request XSL-T from SharePoint to convert each Excel test case row into a JSON or XML payload. TR4E converts the individual rows into an XML structure first. Request XSL-T TR4E-0004Test Case WorkbookTR4E will run against the workbook containing test cases, typically (but not mandatorily) stored in SharePoint Test Case Workbook TR4E-0001Test Case WorksheetContains the individual test cases as rows. Each row will be converted to an API request by TR4E and sent to the Test Subject API Test Case Worksheet TR4E-0002Result WorksheetWill contain the results of each test case run populated by TR4E. Typically will contain one or more expected value and actual value columns with calculated differences. Created by TR4E during the test case run, and named using the run date and time, for example <code>1 Jul 2025 6.04.52 PM EST</code> Result Worksheet TR4E-0012Request JSON or XMLOptionally saved to SharePoint by TR4E Request JSON or XML TR4E-0014Request JSON or XMLSent by TR4E to the test subject API to perform processing Request JSON or XML TR4E-0006Response XSL-TTR4E will use the response XSL-T to convert the Test Subject API XMLor JSON response into a CSV row that is written to the Response Worksheet Response XSL-T TR4E-0003Test History WorksheetPopulated by TR4E - contains summary information about every test case run in this Test Case Workbook Test History Worksheet TR4E-0010Response XSL-TTR4E will load the response XSL-T from SharePoint to convert each Test Subject API response into a CSV row that is written to the Response Worksheet Response XSL-T TR4E-0015Response JSON or XMLSent by the test subject API to TR4E to update the test cases response worksheet Response JSON or XML TR4E-0013Response JSON or XMLOptionally saved to SharePoint by TR4E Response JSON or XML TR4E-0007Request JSON or XMLTR4E will optionally write the request JSON or XML payload to SharePoint. When running in batch mode the requests and responses will be zipped Request JSON or XML TR4E-0008Response JSON or XMLTR4E will optionally write the request JSON or XML payload to SharePoint. When running in batch mode the requests and responses will be zipped Response JSON or XML Save? Save? Save? Save? Microsoft Azure Microsoft Azure TR4E-0016Entra IDTR4E uses Entra ID to perform seamless SSO againt a corporate domain and to obtain JWT access tokens Entra ID Crecy Poitiers Agincourt Solutions Crecy Poitiers Agincourt Solutions Monday, 11 August 2025 TR4E-0017TR4E WorksheetTR4E configuration is used when the TR4E application is launched to configure test case ranges, environments amongst others TR4E Worksheet